PrevRow

Note: This statement is named Previous Recordset Row in the Add Statement dialog box.

Moves to the previous row in a recordset. If the recordset row index is at RecordsetBOF, the index does not change.

Syntax

PrevRow(Recordset)

Arguments

Argument Description
Recordset Recordset name. Must be opened with OpenRecordset or OpenRecordsetQuery.

Example

rs = OpenRecordset("WysiCorp Bugs (Excel)")

LastRow(rs)

While Not RecordsetBOF(rs)

PrintLn(GetRowValue(rs, "First Name"))

PrevRow(rs)

WEnd